Model Table MPCCOM TRANSACTION CODE
This model dimension represents MPCCOM Transaction Code and is based on the IFS
Applications dimension DIM_MPCCOM_TRANSACTION_CODE. All models that refers to this
dimension will have the attributes described below.
Attributes
| Attribute |
Description (where applicable) |
| ID | |
| MPCCOM Transaction | Built as CODE +'-'+ DESCRIPTION |
| MPCCOM Transaction Code | The CODE of the dimensions, i.e. the MPCCOM Transaction
identity |
| MPCCOM Transaction Direction | The direction of the transaction. It describes whether the
quantity in stock is decreased (-), increased (+), or unaffected (0) by
the transaction. |
| MPCCOM Transaction Source | Represents the source for the transaction |
| MPCCOM Transaction Source Application | Represents the transaction application source |
| MPCCOM Transaction Source Application Desc | |
| MPCCOM Transaction Source Desc | Represents the description of the source for the transaction |
| Transaction | Represents the description of the transaction type |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| MPCCOM TRANSACTION CODE | DIM_MPCCOM_TRANSACTION_CODE_TM | DIM_MPCCOM_TRANSACTION_CODE_BI | DIM_MPCCOM_TRANSACTION_CODE | On Line |